package cn.lanqiao.service;

import cn.lanqiao.entity.Student;

import java.util.ArrayList;

public interface StudentService {
//查询所有学生
    int addStudent(Student s);
    ArrayList<Student> queryAllStudent();
 //通过id查询
    Student queryStudentById(int i);
//增加
    int updateStudentInfo(Student student);
 //删除
    int deleteStudent(int student_id);
//分页查询
    ArrayList<Student>  queryStudentBypage(int pageNum, int pageSize);
 //排序功能
    ArrayList<Student> orderAllStudent();
//统计功能
    double maleToFemaleRatio();
    int totalStudents();
    int femaleStudents();
    int  maleStudents();
//批量操作
    void batchAddStudentsService(ArrayList<Student> students);
    void batchDeleteStudentsService(ArrayList<Integer> student_id);
}
